home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software Vault: The Gold Collection
/
Software Vault - The Gold Collection (American Databankers) (1993).ISO
/
cdr11
/
pdox693.zip
/
TI540.ASC
< prev
next >
Wrap
Text File
|
1992-08-12
|
2KB
|
133 lines
PRODUCT : Paradox NUMBER : 540
VERSION : All
OS : DOS
DATE : August 12, 1992 PAGE : 1/2
TITLE : Converting a Field in a Table Using Format
The following script demonstrates the use of SCAN to change
Fieldname to upper case. A complete description of SCAN can be
found in the PAL User's Guide. Refer to the PAL User's Guide's
index under "Scan command" for the page number.
This is handled through the use of FORMAT, which is explained in
detail the PAL User's Guide. Refer to the PAL User's Guide's
index under "Format function" for the page number.
Note:
TBLNAME is the name of the table.
Fieldname is the name of the field.
The following script converts the field Fieldname, in the table
TBLNAME, to upper case, via the use of the FORMAT specification
cu.
EDIT "TBLNAME" ;Place the table in edit mode.
SCAN
[Fieldname] = format("cu",[Fieldname])
ENDSCAN ;Scan and convert field values.
DO_IT! ;Save all changes.
The following script converts the field Fieldname, in Table
TBLNAME, to lower case, via the use of the FORMAT specification
cl.
EDIT "TBLNAME" ;Place the table in edit mode.
SCAN
[Fieldname] = format("cl",[Fieldname])
ENDSCAN ;Scan and convert field values.
DO_IT! ;Save all changes.
The following script converts the field Fieldname, in Table
TBLNAME, to initial capital letter only, via the use of the
FORMAT specification cc.
EDIT "TBLNAME" ;Place the table in edit mode.
SCAN
[Fieldname] = format("cc",lower([Fieldname]))
ENDSCAN ;Scan and convert field values.
DO_IT! ;Save all changes.
PRODUCT : Paradox NUMBER : 540
VERSION : All
OS : DOS
DATE : August 12, 1992 PAGE : 2/2
TITLE : Converting a Field in a Table Using Format
DISCLAIMER: You have the right to use this technical information
subject to the terms of the No-Nonsense License Statement that
you received with the Borland product to which this information
pertains.